A Knowledge-Based Fuzzy Query and Results Ranking Approach for Relational Databases
نویسندگان
چکیده
Users often have vague or imprecise ideas when searching the databases and thus may not know how to precisely formulate queries that lead to satisfactory answers. Based on the fuzzy set thoery, this paper proposes a fuzzy query approach which can support the expression of fuzzy queries and translate the fuzzy query into the precise query in order to provide relevant answers to the users. The fuzzy queries mean that the query condition consists of complex fuzzy terms as the operands and complex fuzzy relations as the operators in a fuzzy query. With the knowledge base related to the application domain and the different thresholds that the user chooses for the fuzzy query, the user fuzzy queries can be translated into precise queries for classical relational databases. For the the fuzzy query results, they are finally ranked according to their satisfaction degree to the original fuzzy query and the user preferences. The efficiency and effectiveness of our approach is also demonstrated by experimental results.
منابع مشابه
Fuzzy multi-criteria selection procedures in choosing data source
Technology assessment and selection has a substantial impact on organizations procedures in regards to technology transfer. Technological decisions are usually made by a group of experts, and whereby integrity of these viewpoints to a single decision can be quite complex. Today, operational databases and data warehouses exist to manage and organize data with specific features and henceforth, th...
متن کاملApply Uncertainty in Document-Oriented Database (MongoDB) Using F-XML
As moving to big data world where data is increasing in unstructured way with high velocity, there is a need of data-store to store this bundle amount of data. Traditionally, relational databases are used which are now not compatible to handle this large amount of data, so it is needed to move on to non-relational data-stores. In the current study, we have proposed an extension of the Mongo...
متن کاملApply Uncertainty in Document-Oriented Database (MongoDB) Using F-XML
As moving to big data world where data is increasing in unstructured way with high velocity, there is a need of data-store to store this bundle amount of data. Traditionally, relational databases are used which are now not compatible to handle this large amount of data, so it is needed to move on to non-relational data-stores. In the current study, we have proposed an extension of the Mongo...
متن کاملRelational Databases Query Optimization using Hybrid Evolutionary Algorithm
Optimizing the database queries is one of hard research problems. Exhaustive search techniques like dynamic programming is suitable for queries with a few relations, but by increasing the number of relations in query, much use of memory and processing is needed, and the use of these methods is not suitable, so we have to use random and evolutionary methods. The use of evolutionary methods, beca...
متن کاملFuzzy rough set techniques for uncertainty processing in a relational database
This paper concerns the modeling of imprecision, vagueness, and uncertainty in databases through an extension of the relational model of data: the fuzzy rough relational database, an approach which uses both fuzzy set and rough set theories for knowledge representation of imprecise data in a relational database model. The fuzzy rough relational database is formally defined, along with a fuzzy r...
متن کامل